Skip to main content

SORT GROUP BY NOSORT

Short Description

SORT GROUP BY NOSORT is a pipeline aggregation step which uses a pre-sorted set of values as input.

Detailed Description​

The step will be seen when the GROUP BY clause is used with aggregate functions such as AVG(), COUNT(), MAX(), MIN() and SUM(). The SORT GROUP BY NOSORT plan element requires the input already being in the correct order for the query and so no sort is required within this operation. Typically these values will be read from an index. This is an aggregation function and only a single row per group is returned and passed onto the next execution step.

Further Reading​

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.